<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `fanwe_deal_cate`;");
E_C("CREATE TABLE `fanwe_deal_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `brief` text NOT NULL,
  `pid` int(11) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `is_effect` tinyint(1) NOT NULL,
  `sort` int(11) NOT NULL,
  `uname` varchar(255) NOT NULL,
  `recommend` tinyint(1) NOT NULL,
  `icon` varchar(255) DEFAULT '' COMMENT '分类icon',
  `rec_youhui` tinyint(1) NOT NULL,
  `rec_daijin` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8");
E_D("replace into `fanwe_deal_cate` values('8','中餐','','0','0','1','7','','1','','1','1');");
E_D("replace into `fanwe_deal_cate` values('9','西餐','','0','0','1','6','','1','','1','1');");
E_D("replace into `fanwe_deal_cate` values('10','火锅','','0','0','1','5','','1','','1','1');");
E_D("replace into `fanwe_deal_cate` values('11','汤锅','','0','0','1','4','','1','','1','1');");
E_D("replace into `fanwe_deal_cate` values('12','自助餐','','0','0','1','3','','1','','1','1');");
E_D("replace into `fanwe_deal_cate` values('13','特色美食','','0','0','1','2','','1','','1','1');");
E_D("replace into `fanwe_deal_cate` values('14','亚洲菜','','0','0','1','1','','1','','1','1');");

require("../../inc/footer.php");
?>